The Ultimate Power Query Cookbook for Power BI and Excel by Raimato Dominick;

Author:Raimato, Dominick;
Language: eng
Format: epub
Publisher: BPB Publications

Figure 8.3: Viewing the profile for the Zone column in our query

The column profile option provides context to our data. In performing our analysis of the Zone column, we can learn a few key facts about our data. For example, we know that there are two hundred sixty-five rows of data, but two are empty. We have no errors to resolve in this column. In addition to those values under column statistics, we can see the different measures we would find with our statistical transformations that we learned about in Chapter 7, Transforming Columns. This allows us to find key statistical figures without having to apply them individually. Lastly, we see a distribution of values in the column that provides context to the values we see. This allows us to understand how our data is distributed. However, if we wish to see this at a high level, we can use the Column distribution option to provide a view of our distribution:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.